﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace com.core.database
{
    public interface IDataAgent
    {
        /// <summary>
        /// 
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        int ExecuteNonQuery(string query);
        /// <summary>
        /// 
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        DataItem[] ExecuteQuery(string query);
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sp">store procedure name</param>
        /// <param name="inParams">input parameters</param>
        /// <returns></returns>
        int ExecuteSP(string sp, DataItem inParams);
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sp"></param>
        /// <param name="outParams"></param>
        /// <param name="inParams"></param>
        /// <returns></returns>
        DataItem[] ExecuteSP(string sp, DataItem inParams, DataItem outParams);
    }
}
